home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Collection of Tools & Utilities
/
Collection of Tools and Utilities.iso
/
dbase
/
qbase.zip
/
QBASE.DOC
< prev
next >
Wrap
Text File
|
1990-01-17
|
26KB
|
659 lines
qBase V1.0
Query for dBase, Clipper, and Foxbase .DBF Files
Copyright 1990
Santa Clarita SoftWorks
Santa Clarita, California
1. What is qBase?
qBase was developed for quick and intuitive query reporting
of existing dBase type .DBF files. The user can design and
structure a custom inquiry in a matter of seconds with a printed
report generated as an option. There is no other demand placed
upon the user other than supplying their own .DBF files and a
minimal amount of database structuring knowledge.
This program will not change the user's files in anyway. It will
only read the original, create a temporary index, and delete that temporary
index. It will require at least 512k of memory with minimal requirements for
free disk space.
qBase was developed and compiled with Clipper version Summer 1987,
a Nantucket Corporation product and trademark.
2. Using qBase.
First step in using qBase is to path or place QBASE.EXE in
the current file directory. To execute qBase, key in QBASE and a
screen similar to Figure 1 will appear. Given any existing
dBase type file, qBase will detect the presence of that or any
other .DBF file in the current directory and the query starts
from that point.
-- FIGURE 1 --
qBase Query for dBase/Clipper/Foxplus Files
╔═════════════╗
║DRAWINGS.DBF ║
║DRAWMAST.DBF ║
║MASTER.DBF ║
║MRP.DBF ║
║PHONE.DBF ║
║PRODUCT.DBF ║ qBase Version 1.0
║PROGRAMS.DBF ║ Copyright 1989
║PURCHASE.DBF ║ Santa Clarita SoftWorks
║SCHEDULE.DBF ║
║STKROOM.DBF ║
----------> ║TIMECARD.DBF ║
║WORK.DBF ║
╚═════════════╝
Use Cursor to Locate File, Enter to Query, ESC to Quit
Select the desired file (TIMECARD.DBF) by moving the light bar to the
file's name and hit the enter key. A screen similar to Figure 2
will appear.
Page 1
-- FIGURE 2 --
Select Report Fields
╔═══════════════╗
║ EMPLOYEE ║
║ JOBNUMBER ║
║ HOURS ║
║ MONTH ║
║ WEEK ║
╚═══════════════╝
╔═══════════════╗
║ Enter - Select║
║ F5- Tags All ║
║ F6- Untags All║
║ ║
║ Sort Menu ===>║
╚═══════════════╝
REPORT FIELDS
The window title 'Report Fields' is the user's selection
menu for what fields will appear in the final report. To select the
desired fields hit the enter key while the field is highlighted by
the light bar, or hit the F5 function key to mark all of the data
fields for the final report. A checkmark will appear to the right
of the selected reporting data fields.
To access all of available fields in the user's file, scroll
down or up with the cursor keys to view additional data fields.
If you wish to alter the selection after marking, simply
press the enter key while highlighting the checkmarked field and
the field will be untagged and will not be presented in the final
report. To unmark all of the fields, press the F6 function key
to globally remove the checkmarks and return to a clean slate.
After selection of the fields, press the right arrow cursor
key to move to the next window for sort selection.
During the qBase session, the parameters that you are setting for
the query are being echoed at the top half of the screen. The message will
give a string that will be dynamically changed when you make the change,
and continued on to be printed on the final report.
Page 2
SORT FIELDS
Figure 3 depicts how the screen should appear after the
Report Field selection has been completed. The datafield list
will appear as it did in Report Fields window.
-- FIGURE 3 --
Select Report Fields Select Sort Fields
╔═══════════════╗ ╔═══════════════╗
║ EMPLOYEE √ ║ ║ EMPLOYEE ║
║ JOBNUMBER √ ║ ║ JOBNUMBER ║
║ HOURS √ ║ ║ HOURS ║
║ MONTH √ ║ ║ MONTH ║
║ WEEK √ ║ ║ WEEK ║
╚═══════════════╝ ╚═══════════════╝
╔═══════════════╗
║ Enter - Select║
║ Order ║
║ Erase - Enter ║
║ Over Any Pick║
║ <=== Menu ===>║
╚═══════════════╝
This window will allow the user to select what order the
data will appear in the final query. A sort order is not
necessary for qBase and to by pass this window, use the right
cursor key to move on to the next field selection menu.
The light bar is used for selecting fields in sorting the
final query. Use the Enter key to mark the first field in the
sort order. A number '1' (EMPLOYEE) will appear to the right of
the that field designating it as the first field in the ascending sort
order. To add another field for the sort order, hit the Enter
key while highlighting the desired field and a number '2' (MONTH) will
appear to the right. Continue to select fields for the sort
order by the light bar and enter key until the final sort order
has been determined and marked with a numeric character.
To change the sort order, simply place the light bar on a
previously selected field and use the enter key to erase all of
the numeric marks and start over.
Finalized the sort order by using the right cursor key to
move into the Criteria selection menu.
Page 3
CRITERIA FIELD
To construct the query, the third window as pictured in
Figure 4 is used for selecting what field will be the 'subject'
for criteria. Press the enter key on the a select field (EMPLOYEE)
and arrowhead will appear to the right point to the field name. To
change this 'subject' field, hit enter on the same field to blank
out the arrowhead, or hit the enter key on another field for a
new selection. There can only be one field selected in this stage.
-- FIGURE 4 --
TIMECARD.DBF is sorted on EMPLOYEE, MONTH
Where